Car Prices Report

Dataset statistics

Number of variables	16
Number of observations	549304
Missing cells	116573
Missing cells (%)	1.3%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	71.2 MiB
Average record size in memory	136.0 B

Variable types

Numeric	5
Text	8
Categorical	3

Alerts

`transmission` is highly imbalanced (89.1%)	Imbalance
`interior` is highly imbalanced (50.9%)	Imbalance
`make` has 9259 (1.7%) missing values	Missing
`model` has 9357 (1.7%) missing values	Missing
`trim` has 9561 (1.7%) missing values	Missing
`body` has 11767 (2.1%) missing values	Missing
`transmission` has 64016 (11.7%) missing values	Missing
`condition` has 11001 (2.0%) missing values	Missing

Reproduction

Analysis started	2024-04-01 15:59:08.684941
Analysis finished	2024-04-01 15:59:48.915469
Duration	40.23 seconds
Software version	ydata-profiling vv4.7.0
Download configuration	config.json

year
Real number (ℝ)

Distinct	16
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2010.2606

Minimum	2000
Maximum	2015
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.4 MiB

Quantile statistics

Minimum	2000
5-th percentile	2003
Q1	2008
median	2012
Q3	2013
95-th percentile	2014
Maximum	2015
Range	15
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	3.6129215
Coefficient of variation (CV)	0.0017972403
Kurtosis	-0.10447531
Mean	2010.2606
Median Absolute Deviation (MAD)	2
Skewness	-0.94383354
Sum	1.1042442 × 10⁹
Variance	13.053202
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
2012	102315	18.6%
2013	98168	17.9%
2014	81070	14.8%
2011	48548	8.8%
2008	31502	5.7%
2007	30845	5.6%
2006	26913	4.9%
2010	26485	4.8%
2005	21394	3.9%
2009	20594	3.7%
Other values (6)	61470	11.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2000	5227	1.0%
2001	6468	1.2%
2002	9715	1.8%
2003	13281	2.4%
2004	17342	3.2%
2005	21394	3.9%
2006	26913	4.9%
2007	30845	5.6%
2008	31502	5.7%
2009	20594	3.7%

Value	Count	Frequency (%)
2015	9437	1.7%
2014	81070	14.8%
2013	98168	17.9%
2012	102315	18.6%
2011	48548	8.8%
2010	26485	4.8%
2009	20594	3.7%
2008	31502	5.7%
2007	30845	5.6%
2006	26913	4.9%

make
Text

MISSING

Distinct	92
Distinct (%)	< 0.1%
Missing	9259
Missing (%)	1.7%
Memory size	8.4 MiB

Length

Max length	13
Median length	11
Mean length	5.9939524
Min length	2

Characters and Unicode

Total characters	3237004
Distinct characters	49
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	6 ?
Unique (%)	< 0.1%

Sample

1st row	Kia
2nd row	Kia
3rd row	BMW
4th row	Volvo
5th row	BMW

Value	Count	Frequency (%)
ford	92853	17.1%
chevrolet	59908	11.1%
nissan	53525	9.9%
toyota	38741	7.1%
dodge	30770	5.7%
honda	26255	4.8%
hyundai	21836	4.0%
bmw	20506	3.8%
kia	18078	3.3%
chrysler	17379	3.2%
Other values (52)	162077	29.9%

Most occurring characters

Value	Count	Frequency (%)
o	322325	10.0%
e	295829	9.1%
a	231247	7.1%
r	226956	7.0%
d	212574	6.6%
n	183457	5.7%
i	183078	5.7%
s	176214	5.4%
t	125908	3.9%
l	114889	3.5%
Other values (39)	1164527	36.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3237004	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	322325	10.0%
e	295829	9.1%
a	231247	7.1%
r	226956	7.0%
d	212574	6.6%
n	183457	5.7%
i	183078	5.7%
s	176214	5.4%
t	125908	3.9%
l	114889	3.5%
Other values (39)	1164527	36.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3237004	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	322325	10.0%
e	295829	9.1%
a	231247	7.1%
r	226956	7.0%
d	212574	6.6%
n	183457	5.7%
i	183078	5.7%
s	176214	5.4%
t	125908	3.9%
l	114889	3.5%
Other values (39)	1164527	36.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3237004	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	322325	10.0%
e	295829	9.1%
a	231247	7.1%
r	226956	7.0%
d	212574	6.6%
n	183457	5.7%
i	183078	5.7%
s	176214	5.4%
t	125908	3.9%
l	114889	3.5%
Other values (39)	1164527	36.0%

model
Text

MISSING

Distinct	894
Distinct (%)	0.2%
Missing	9357
Missing (%)	1.7%
Memory size	8.4 MiB

Length

Max length	29
Median length	23
Mean length	6.7663215
Min length	1

Characters and Unicode

Total characters	3653455
Distinct characters	66
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	56 ?
Unique (%)	< 0.1%

Sample

1st row	Sorento
2nd row	Sorento
3rd row	3 Series
4th row	S60
5th row	6 Series Gran Coupe

Value	Count	Frequency (%)
altima	19279	2.9%
series	15144	2.3%
grand	14584	2.2%
f-150	14340	2.2%
1500	14311	2.2%
fusion	13639	2.1%
camry	12933	2.0%
escape	12027	1.8%
focus	10463	1.6%
g	9333	1.4%
Other values (682)	522939	79.4%

Most occurring characters

Value	Count	Frequency (%)
a	371398	10.2%
r	271372	7.4%
e	265203	7.3%
o	192334	5.3%
n	182740	5.0%
i	167332	4.6%
s	147938	4.0%
t	134679	3.7%
l	130333	3.6%
C	120882	3.3%
Other values (56)	1669244	45.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3653455	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	371398	10.2%
r	271372	7.4%
e	265203	7.3%
o	192334	5.3%
n	182740	5.0%
i	167332	4.6%
s	147938	4.0%
t	134679	3.7%
l	130333	3.6%
C	120882	3.3%
Other values (56)	1669244	45.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3653455	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	371398	10.2%
r	271372	7.4%
e	265203	7.3%
o	192334	5.3%
n	182740	5.0%
i	167332	4.6%
s	147938	4.0%
t	134679	3.7%
l	130333	3.6%
C	120882	3.3%
Other values (56)	1669244	45.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3653455	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	371398	10.2%
r	271372	7.4%
e	265203	7.3%
o	192334	5.3%
n	182740	5.0%
i	167332	4.6%
s	147938	4.0%
t	134679	3.7%
l	130333	3.6%
C	120882	3.3%
Other values (56)	1669244	45.7%

trim
Text

MISSING

Distinct	1803
Distinct (%)	0.3%
Missing	9561
Missing (%)	1.7%
Memory size	8.4 MiB

Length

Max length	46
Median length	37
Mean length	4.7489898
Min length	1

Characters and Unicode

Total characters	2563234
Distinct characters	71
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	207 ?
Unique (%)	< 0.1%

Sample

1st row	LX
2nd row	LX
3rd row	328i SULEV
4th row	T5
5th row	650i

Value	Count	Frequency (%)
base	54472	8.2%
se	48024	7.2%
s	30261	4.6%
lx	20748	3.1%
limited	20404	3.1%
lt	20112	3.0%
2.5	18853	2.8%
xlt	18441	2.8%
ls	17551	2.6%
sport	17493	2.6%
Other values (892)	396465	59.8%

Most occurring characters

Value	Count	Frequency (%)
L	211724	8.3%
S	204581	8.0%
e	152564	6.0%
i	134145	5.2%
E	124980	4.9%
	123081	4.8%
T	120090	4.7%
a	106540	4.2%
r	97083	3.8%
X	89373	3.5%
Other values (61)	1199073	46.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2563234	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
L	211724	8.3%
S	204581	8.0%
e	152564	6.0%
i	134145	5.2%
E	124980	4.9%
	123081	4.8%
T	120090	4.7%
a	106540	4.2%
r	97083	3.8%
X	89373	3.5%
Other values (61)	1199073	46.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2563234	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
L	211724	8.3%
S	204581	8.0%
e	152564	6.0%
i	134145	5.2%
E	124980	4.9%
	123081	4.8%
T	120090	4.7%
a	106540	4.2%
r	97083	3.8%
X	89373	3.5%
Other values (61)	1199073	46.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2563234	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
L	211724	8.3%
S	204581	8.0%
e	152564	6.0%
i	134145	5.2%
E	124980	4.9%
	123081	4.8%
T	120090	4.7%
a	106540	4.2%
r	97083	3.8%
X	89373	3.5%
Other values (61)	1199073	46.8%

body
Text

MISSING

Distinct	87
Distinct (%)	< 0.1%
Missing	11767
Missing (%)	2.1%
Memory size	8.4 MiB

Length

Max length	23
Median length	5
Mean length	5.2779306
Min length	3

Characters and Unicode

Total characters	2837083
Distinct characters	48
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5 ?
Unique (%)	< 0.1%

Sample

1st row	SUV
2nd row	SUV
3rd row	Sedan
4th row	Sedan
5th row	Sedan

Value	Count	Frequency (%)
sedan	244069	41.9%
suv	142309	24.4%
cab	32622	5.6%
hatchback	26065	4.5%
minivan	25529	4.4%
coupe	19337	3.3%
crew	16393	2.8%
wagon	15991	2.7%
convertible	10599	1.8%
g	9333	1.6%
Other values (33)	40071	6.9%

Most occurring characters

Value	Count	Frequency (%)
a	392077	13.8%
e	345501	12.2%
n	333296	11.7%
S	332816	11.7%
d	256884	9.1%
V	123431	4.4%
U	117947	4.2%
C	77228	2.7%
b	76442	2.7%
s	73109	2.6%
Other values (38)	708352	25.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2837083	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	392077	13.8%
e	345501	12.2%
n	333296	11.7%
S	332816	11.7%
d	256884	9.1%
V	123431	4.4%
U	117947	4.2%
C	77228	2.7%
b	76442	2.7%
s	73109	2.6%
Other values (38)	708352	25.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2837083	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	392077	13.8%
e	345501	12.2%
n	333296	11.7%
S	332816	11.7%
d	256884	9.1%
V	123431	4.4%
U	117947	4.2%
C	77228	2.7%
b	76442	2.7%
s	73109	2.6%
Other values (38)	708352	25.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2837083	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	392077	13.8%
e	345501	12.2%
n	333296	11.7%
S	332816	11.7%
d	256884	9.1%
V	123431	4.4%
U	117947	4.2%
C	77228	2.7%
b	76442	2.7%
s	73109	2.6%
Other values (38)	708352	25.0%

transmission
Categorical

IMBALANCE MISSING

Distinct	4
Distinct (%)	< 0.1%
Missing	64016
Missing (%)	11.7%
Memory size	8.4 MiB

automatic	468495
manual	16767
sedan	15
Sedan	11

Length

Max length	9
Median length	9
Mean length	8.8961338
Min length	5

Characters and Unicode

Total characters	4317187
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	automatic
2nd row	automatic
3rd row	automatic
4th row	automatic
5th row	automatic

Common Values

Value	Count	Frequency (%)
automatic	468495	85.3%
manual	16767	3.1%
sedan	15	< 0.1%
Sedan	11	< 0.1%
(Missing)	64016	11.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
automatic	468495	96.5%
manual	16767	3.5%
sedan	26	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
a	970550	22.5%
t	936990	21.7%
u	485262	11.2%
m	485262	11.2%
o	468495	10.9%
i	468495	10.9%
c	468495	10.9%
n	16793	0.4%
l	16767	0.4%
e	26	< 0.1%
Other values (3)	52	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	4317187	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	970550	22.5%
t	936990	21.7%
u	485262	11.2%
m	485262	11.2%
o	468495	10.9%
i	468495	10.9%
c	468495	10.9%
n	16793	0.4%
l	16767	0.4%
e	26	< 0.1%
Other values (3)	52	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	4317187	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	970550	22.5%
t	936990	21.7%
u	485262	11.2%
m	485262	11.2%
o	468495	10.9%
i	468495	10.9%
c	468495	10.9%
n	16793	0.4%
l	16767	0.4%
e	26	< 0.1%
Other values (3)	52	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	4317187	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	970550	22.5%
t	936990	21.7%
u	485262	11.2%
m	485262	11.2%
o	468495	10.9%
i	468495	10.9%
c	468495	10.9%
n	16793	0.4%
l	16767	0.4%
e	26	< 0.1%
Other values (3)	52	< 0.1%

vin
Text

Distinct	540830
Distinct (%)	98.5%
Missing	4
Missing (%)	< 0.1%
Memory size	8.4 MiB

Length

Max length	17
Median length	17
Mean length	16.99968
Min length	9

Characters and Unicode

Total characters	9337924
Distinct characters	35
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	532567 ?
Unique (%)	97.0%

Sample

1st row	5xyktca69fg566472
2nd row	5xyktca69fg561319
3rd row	wba3c1c51ek116351
4th row	yv1612tb4f1310987
5th row	wba6b2c57ed129731

Value	Count	Frequency (%)
automatic	22	< 0.1%
wbanv13588cz57827	5	< 0.1%
trusc28n241022003	4	< 0.1%
5n1ar1nn2bc632869	4	< 0.1%
wddgf56x78f009940	4	< 0.1%
1ftfw1cv5afb30053	4	< 0.1%
5uxfe43579l274932	4	< 0.1%
4t1bk1eb4du026484	3	< 0.1%
1g2mb33b56y108249	3	< 0.1%
1g1pa5sh7d7298502	3	< 0.1%
Other values (540820)	549244	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
1	901723	9.7%
2	623541	6.7%
3	603375	6.5%
5	585726	6.3%
4	564627	6.0%
0	489167	5.2%
6	478850	5.1%
7	451632	4.8%
8	447238	4.8%
c	378243	4.1%
Other values (25)	3813802	40.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	9337924	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	901723	9.7%
2	623541	6.7%
3	603375	6.5%
5	585726	6.3%
4	564627	6.0%
0	489167	5.2%
6	478850	5.1%
7	451632	4.8%
8	447238	4.8%
c	378243	4.1%
Other values (25)	3813802	40.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	9337924	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	901723	9.7%
2	623541	6.7%
3	603375	6.5%
5	585726	6.3%
4	564627	6.0%
0	489167	5.2%
6	478850	5.1%
7	451632	4.8%
8	447238	4.8%
c	378243	4.1%
Other values (25)	3813802	40.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	9337924	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	901723	9.7%
2	623541	6.7%
3	603375	6.5%
5	585726	6.3%
4	564627	6.0%
0	489167	5.2%
6	478850	5.1%
7	451632	4.8%
8	447238	4.8%
c	378243	4.1%
Other values (25)	3813802	40.8%

state
Text

Distinct	64
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.4 MiB

Length

Max length	17
Median length	2
Mean length	2.00071
Min length	2

Characters and Unicode

Total characters	1098998
Distinct characters	36
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	26 ?
Unique (%)	< 0.1%

Sample

1st row	ca
2nd row	ca
3rd row	ca
4th row	ca
5th row	ca

Value	Count	Frequency (%)
fl	81399	14.8%
ca	71678	13.0%
pa	53484	9.7%
tx	45314	8.2%
ga	34106	6.2%
nj	27506	5.0%
il	23323	4.2%
oh	21278	3.9%
nc	21120	3.8%
tn	20740	3.8%
Other values (54)	149356	27.2%

Most occurring characters

Value	Count	Frequency (%)
a	196030	17.8%
n	108557	9.9%
l	106891	9.7%
c	105938	9.6%
f	81425	7.4%
t	67832	6.2%
m	59718	5.4%
p	56124	5.1%
i	54005	4.9%
o	49538	4.5%
Other values (26)	212940	19.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1098998	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	196030	17.8%
n	108557	9.9%
l	106891	9.7%
c	105938	9.6%
f	81425	7.4%
t	67832	6.2%
m	59718	5.4%
p	56124	5.1%
i	54005	4.9%
o	49538	4.5%
Other values (26)	212940	19.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1098998	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	196030	17.8%
n	108557	9.9%
l	106891	9.7%
c	105938	9.6%
f	81425	7.4%
t	67832	6.2%
m	59718	5.4%
p	56124	5.1%
i	54005	4.9%
o	49538	4.5%
Other values (26)	212940	19.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1098998	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	196030	17.8%
n	108557	9.9%
l	106891	9.7%
c	105938	9.6%
f	81425	7.4%
t	67832	6.2%
m	59718	5.4%
p	56124	5.1%
i	54005	4.9%
o	49538	4.5%
Other values (26)	212940	19.4%

condition
Real number (ℝ)

MISSING

Distinct	41
Distinct (%)	< 0.1%
Missing	11001
Missing (%)	2.0%
Infinite	0
Infinite (%)	0.0%
Mean	30.962993

Minimum	1
Maximum	49
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.4 MiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	24
median	35
Q3	42
95-th percentile	47
Maximum	49
Range	48
Interquartile range (IQR)	18

Descriptive statistics

Standard deviation	13.22967
Coefficient of variation (CV)	0.4272736
Kurtosis	-0.1411354
Mean	30.962993
Median Absolute Deviation (MAD)	8
Skewness	-0.85929991
Sum	16667472
Variance	175.02416
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=41)

Value	Count	Frequency (%)
19	40154	7.3%
35	26637	4.8%
37	25886	4.7%
44	25495	4.6%
43	24919	4.5%
42	24308	4.4%
36	23084	4.2%
41	23057	4.2%
39	19892	3.6%
4	19881	3.6%
Other values (31)	284990	51.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	6008	1.1%
2	18296	3.3%
3	10369	1.9%
4	19881	3.6%
5	11212	2.0%
11	82	< 0.1%
12	94	< 0.1%
13	81	< 0.1%
14	126	< 0.1%
15	141	< 0.1%

Value	Count	Frequency (%)
49	13096	2.4%
48	12707	2.3%
47	11361	2.1%
46	12628	2.3%
45	12306	2.2%
44	25495	4.6%
43	24919	4.5%
42	24308	4.4%
41	23057	4.2%
39	19892	3.6%

odometer
Real number (ℝ)

Distinct	167981
Distinct (%)	30.6%
Missing	84
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	66670.544

Minimum	1
Maximum	999999
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.4 MiB

Quantile statistics

Minimum	1
5-th percentile	10457
Q1	28053
median	51190
Q3	96929
95-th percentile	164766
Maximum	999999
Range	999998
Interquartile range (IQR)	68876

Descriptive statistics

Standard deviation	51626.514
Coefficient of variation (CV)	0.77435267
Kurtosis	14.181866
Mean	66670.544
Median Absolute Deviation (MAD)	29545
Skewness	1.8452578
Sum	3.6616796 × 10¹⁰
Variance	2.6652969 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1117	0.2%
999999	66	< 0.1%
10	28	< 0.1%
21587	21	< 0.1%
8	18	< 0.1%
29137	18	< 0.1%
21310	18	< 0.1%
19926	17	< 0.1%
35314	17	< 0.1%
36007	17	< 0.1%
Other values (167971)	547883	99.7%
(Missing)	84	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1117	0.2%
2	17	< 0.1%
3	9	< 0.1%
4	9	< 0.1%
5	17	< 0.1%
6	13	< 0.1%
7	13	< 0.1%
8	18	< 0.1%
9	11	< 0.1%
10	28	< 0.1%

Value	Count	Frequency (%)
999999	66	< 0.1%
694978	2	< 0.1%
621388	1	< 0.1%
580956	1	< 0.1%
537334	1	< 0.1%
522212	1	< 0.1%
500227	1	< 0.1%
495757	1	< 0.1%
480747	1	< 0.1%
471114	1	< 0.1%

color
Categorical

Distinct	46
Distinct (%)	< 0.1%
Missing	731
Missing (%)	0.1%
Memory size	8.4 MiB

black	109658
white	104934
silver	82406
gray	82270
blue	50254
Other values (41)	119051

Length

Max length	9
Median length	8
Mean length	4.6253024
Min length	1

Characters and Unicode

Total characters	2537316
Distinct characters	35
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	26 ?
Unique (%)	< 0.1%

Sample

1st row	white
2nd row	white
3rd row	gray
4th row	white
5th row	gray

Common Values

Value	Count	Frequency (%)
black	109658	20.0%
white	104934	19.1%
silver	82406	15.0%
gray	82270	15.0%
blue	50254	9.1%
red	42579	7.8%
—	24606	4.5%
gold	10698	1.9%
green	10051	1.8%
beige	8791	1.6%
Other values (36)	22326	4.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
black	109658	20.0%
white	104934	19.1%
silver	82406	15.0%
gray	82270	15.0%
blue	50254	9.2%
red	42579	7.8%
—	24606	4.5%
gold	10698	2.0%
green	10051	1.8%
beige	8791	1.6%
Other values (36)	22326	4.1%

Most occurring characters

Value	Count	Frequency (%)
e	324327	12.8%
l	257510	10.1%
r	236856	9.3%
i	197834	7.8%
a	194948	7.7%
b	184016	7.3%
g	122578	4.8%
w	114241	4.5%
c	110610	4.4%
k	109699	4.3%
Other values (25)	684697	27.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2537316	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	324327	12.8%
l	257510	10.1%
r	236856	9.3%
i	197834	7.8%
a	194948	7.7%
b	184016	7.3%
g	122578	4.8%
w	114241	4.5%
c	110610	4.4%
k	109699	4.3%
Other values (25)	684697	27.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2537316	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	324327	12.8%
l	257510	10.1%
r	236856	9.3%
i	197834	7.8%
a	194948	7.7%
b	184016	7.3%
g	122578	4.8%
w	114241	4.5%
c	110610	4.4%
k	109699	4.3%
Other values (25)	684697	27.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2537316	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	324327	12.8%
l	257510	10.1%
r	236856	9.3%
i	197834	7.8%
a	194948	7.7%
b	184016	7.3%
g	122578	4.8%
w	114241	4.5%
c	110610	4.4%
k	109699	4.3%
Other values (25)	684697	27.0%

interior
Categorical

IMBALANCE

Distinct	17
Distinct (%)	< 0.1%
Missing	731
Missing (%)	0.1%
Memory size	8.4 MiB

black	243541
gray	174572
beige	58239
tan	42506
—	16117
Other values (12)	13598

Length

Max length	9
Median length	5
Mean length	4.4096829
Min length	1

Characters and Unicode

Total characters	2419033
Distinct characters	23
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	black
2nd row	beige
3rd row	black
4th row	black
5th row	black

Common Values

Value	Count	Frequency (%)
black	243541	44.3%
gray	174572	31.8%
beige	58239	10.6%
tan	42506	7.7%
—	16117	2.9%
brown	8445	1.5%
red	1302	0.2%
silver	1081	0.2%
blue	860	0.2%
off-white	480	0.1%
Other values (7)	1430	0.3%
(Missing)	731	0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
black	243541	44.4%
gray	174572	31.8%
beige	58239	10.6%
tan	42506	7.7%
—	16117	2.9%
brown	8445	1.5%
red	1302	0.2%
silver	1081	0.2%
blue	860	0.2%
off-white	480	0.1%
Other values (7)	1430	0.3%

Most occurring characters

Value	Count	Frequency (%)
a	460764	19.0%
b	311257	12.9%
l	246141	10.2%
c	243541	10.1%
k	243541	10.1%
g	233659	9.7%
r	186251	7.7%
y	174763	7.2%
e	121372	5.0%
i	60051	2.5%
Other values (13)	137693	5.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2419033	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	460764	19.0%
b	311257	12.9%
l	246141	10.2%
c	243541	10.1%
k	243541	10.1%
g	233659	9.7%
r	186251	7.7%
y	174763	7.2%
e	121372	5.0%
i	60051	2.5%
Other values (13)	137693	5.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2419033	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	460764	19.0%
b	311257	12.9%
l	246141	10.2%
c	243541	10.1%
k	243541	10.1%
g	233659	9.7%
r	186251	7.7%
y	174763	7.2%
e	121372	5.0%
i	60051	2.5%
Other values (13)	137693	5.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2419033	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	460764	19.0%
b	311257	12.9%
l	246141	10.2%
c	243541	10.1%
k	243541	10.1%
g	233659	9.7%
r	186251	7.7%
y	174763	7.2%
e	121372	5.0%
i	60051	2.5%
Other values (13)	137693	5.7%

seller
Text

Distinct	14046
Distinct (%)	2.6%
Missing	0
Missing (%)	0.0%
Memory size	8.4 MiB

Length

Max length	50
Median length	42
Mean length	22.992733
Min length	3

Characters and Unicode

Total characters	12630000
Distinct characters	47
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4878 ?
Unique (%)	0.9%

Sample

1st row	kia motors america inc
2nd row	kia motors america inc
3rd row	financial services remarketing (lease)
4th row	volvo na rep/world omni
5th row	financial services remarketing (lease)

Value	Count	Frequency (%)
inc	85250	4.6%
corporation	47760	2.6%
services	47721	2.6%
credit	46782	2.5%
auto	46580	2.5%
motor	45706	2.5%
llc	45233	2.4%
financial	43844	2.4%
ford	35704	1.9%
remarketing	34655	1.9%
Other values (8464)	1368236	74.1%

Most occurring characters

Value	Count	Frequency (%)
	1316832	10.4%
e	1126416	8.9%
a	1034095	8.2%
r	946432	7.5%
n	938616	7.4%
i	904340	7.2%
o	847048	6.7%
t	781370	6.2%
c	725514	5.7%
s	660727	5.2%
Other values (37)	3348610	26.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	12630000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	1316832	10.4%
e	1126416	8.9%
a	1034095	8.2%
r	946432	7.5%
n	938616	7.4%
i	904340	7.2%
o	847048	6.7%
t	781370	6.2%
c	725514	5.7%
s	660727	5.2%
Other values (37)	3348610	26.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	12630000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	1316832	10.4%
e	1126416	8.9%
a	1034095	8.2%
r	946432	7.5%
n	938616	7.4%
i	904340	7.2%
o	847048	6.7%
t	781370	6.2%
c	725514	5.7%
s	660727	5.2%
Other values (37)	3348610	26.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	12630000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	1316832	10.4%
e	1126416	8.9%
a	1034095	8.2%
r	946432	7.5%
n	938616	7.4%
i	904340	7.2%
o	847048	6.7%
t	781370	6.2%
c	725514	5.7%
s	660727	5.2%
Other values (37)	3348610	26.5%

mmr
Real number (ℝ)

Distinct	1101
Distinct (%)	0.2%
Missing	38
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	13985.554

Minimum	25
Maximum	182000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.4 MiB

Quantile statistics

Minimum	25
5-th percentile	2150
Q1	7475
median	12400
Q3	18450
95-th percentile	30800
Maximum	182000
Range	181975
Interquartile range (IQR)	10975

Descriptive statistics

Standard deviation	9620.9282
Coefficient of variation (CV)	0.68791897
Kurtosis	11.820587
Mean	13985.554
Median Absolute Deviation (MAD)	5450
Skewness	2.0411483
Sum	7.6817895 × 10⁹
Variance	92562259
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12500	1761	0.3%
11600	1751	0.3%
11650	1746	0.3%
12150	1722	0.3%
11300	1716	0.3%
11850	1716	0.3%
11750	1708	0.3%
12350	1701	0.3%
12700	1701	0.3%
11950	1694	0.3%
Other values (1091)	532050	96.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
25	21	< 0.1%
50	34	< 0.1%
75	15	< 0.1%
100	22	< 0.1%
125	32	< 0.1%
150	28	< 0.1%
175	44	< 0.1%
200	34	< 0.1%
225	36	< 0.1%
250	57	< 0.1%

Value	Count	Frequency (%)
182000	1	< 0.1%
178000	1	< 0.1%
176000	1	< 0.1%
172000	1	< 0.1%
170000	3	< 0.1%
166000	3	< 0.1%
164000	1	< 0.1%
163000	1	< 0.1%
162000	1	< 0.1%
161000	1	< 0.1%

sellingprice
Real number (ℝ)

Distinct	1885
Distinct (%)	0.3%
Missing	12
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	13825.543

Minimum	1
Maximum	230000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.4 MiB

Quantile statistics

Minimum	1
5-th percentile	1800
Q1	7200
median	12300
Q3	18400
95-th percentile	30800
Maximum	230000
Range	229999
Interquartile range (IQR)	11200

Descriptive statistics

Standard deviation	9694.1377
Coefficient of variation (CV)	0.70117593
Kurtosis	11.463063
Mean	13825.543
Median Absolute Deviation (MAD)	5500
Skewness	1.9923523
Sum	7.5942599 × 10⁹
Variance	93976306
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12000	4450	0.8%
11000	4450	0.8%
13000	4334	0.8%
10000	4028	0.7%
14000	3898	0.7%
11500	3875	0.7%
12500	3713	0.7%
9000	3685	0.7%
10500	3539	0.6%
15000	3385	0.6%
Other values (1875)	509935	92.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	3	< 0.1%
100	14	< 0.1%
150	5	< 0.1%
175	4	< 0.1%
200	80	< 0.1%
225	55	< 0.1%
250	146	< 0.1%
275	64	< 0.1%
300	673	0.1%
325	110	< 0.1%

Value	Count	Frequency (%)
230000	1	< 0.1%
183000	1	< 0.1%
173000	1	< 0.1%
171500	1	< 0.1%
169500	1	< 0.1%
169000	1	< 0.1%
167000	1	< 0.1%
165000	2	< 0.1%
163000	2	< 0.1%
161000	1	< 0.1%

saledate
Text

Distinct	3732
Distinct (%)	0.7%
Missing	12
Missing (%)	< 0.1%
Memory size	8.4 MiB

Length

Max length	39
Median length	39
Mean length	38.998382
Min length	4

Characters and Unicode

Total characters	21421499
Distinct characters	40
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	592 ?
Unique (%)	0.1%

Sample

1st row	Tue Dec 16 2014 12:30:00 GMT-0800 (PST)
2nd row	Tue Dec 16 2014 12:30:00 GMT-0800 (PST)
3rd row	Thu Jan 15 2015 04:30:00 GMT-0800 (PST)
4th row	Thu Jan 29 2015 04:30:00 GMT-0800 (PST)
5th row	Thu Dec 18 2014 12:30:00 GMT-0800 (PST)

Value	Count	Frequency (%)
2015	497293	12.9%
gmt-0800	387885	10.1%
pst	387885	10.1%
wed	163676	4.3%
pdt	161381	4.2%
gmt-0700	161381	4.2%
feb	160453	4.2%
tue	160372	4.2%
thu	151048	3.9%
jan	138223	3.6%
Other values (332)	1475291	38.4%

Most occurring characters

Value	Count	Frequency (%)
0	4738192	22.1%
	3295596	15.4%
T	1409952	6.6%
:	1098532	5.1%
1	1042238	4.9%
2	947100	4.4%
M	661852	3.1%
5	649562	3.0%
G	549266	2.6%
)	549266	2.6%
Other values (30)	6479943	30.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	21421499	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	4738192	22.1%
	3295596	15.4%
T	1409952	6.6%
:	1098532	5.1%
1	1042238	4.9%
2	947100	4.4%
M	661852	3.1%
5	649562	3.0%
G	549266	2.6%
)	549266	2.6%
Other values (30)	6479943	30.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	21421499	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	4738192	22.1%
	3295596	15.4%
T	1409952	6.6%
:	1098532	5.1%
1	1042238	4.9%
2	947100	4.4%
M	661852	3.1%
5	649562	3.0%
G	549266	2.6%
)	549266	2.6%
Other values (30)	6479943	30.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	21421499	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	4738192	22.1%
	3295596	15.4%
T	1409952	6.6%
:	1098532	5.1%
1	1042238	4.9%
2	947100	4.4%
M	661852	3.1%
5	649562	3.0%
G	549266	2.6%
)	549266	2.6%
Other values (30)	6479943	30.2%

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	year	make	model	trim	body	transmission	vin	state	condition	odometer	color	interior	seller	mmr	sellingprice	saledate
0	2015	Kia	Sorento	LX	SUV	automatic	5xyktca69fg566472	ca	5.0	16639.0	white	black	kia motors america inc	20500.0	21500.0	Tue Dec 16 2014 12:30:00 GMT-0800 (PST)
1	2015	Kia	Sorento	LX	SUV	automatic	5xyktca69fg561319	ca	5.0	9393.0	white	beige	kia motors america inc	20800.0	21500.0	Tue Dec 16 2014 12:30:00 GMT-0800 (PST)
2	2014	BMW	3 Series	328i SULEV	Sedan	automatic	wba3c1c51ek116351	ca	45.0	1331.0	gray	black	financial services remarketing (lease)	31900.0	30000.0	Thu Jan 15 2015 04:30:00 GMT-0800 (PST)
3	2015	Volvo	S60	T5	Sedan	automatic	yv1612tb4f1310987	ca	41.0	14282.0	white	black	volvo na rep/world omni	27500.0	27750.0	Thu Jan 29 2015 04:30:00 GMT-0800 (PST)
4	2014	BMW	6 Series Gran Coupe	650i	Sedan	automatic	wba6b2c57ed129731	ca	43.0	2641.0	gray	black	financial services remarketing (lease)	66000.0	67000.0	Thu Dec 18 2014 12:30:00 GMT-0800 (PST)
5	2015	Nissan	Altima	2.5 S	Sedan	automatic	1n4al3ap1fn326013	ca	1.0	5554.0	gray	black	enterprise vehicle exchange / tra / rental / tulsa	15350.0	10900.0	Tue Dec 30 2014 12:00:00 GMT-0800 (PST)
6	2014	BMW	M5	Base	Sedan	automatic	wbsfv9c51ed593089	ca	34.0	14943.0	black	black	the hertz corporation	69000.0	65000.0	Wed Dec 17 2014 12:30:00 GMT-0800 (PST)
7	2014	Chevrolet	Cruze	1LT	Sedan	automatic	1g1pc5sb2e7128460	ca	2.0	28617.0	black	black	enterprise vehicle exchange / tra / rental / tulsa	11900.0	9800.0	Tue Dec 16 2014 13:00:00 GMT-0800 (PST)
8	2014	Audi	A4	2.0T Premium Plus quattro	Sedan	automatic	wauffafl3en030343	ca	42.0	9557.0	white	black	audi mission viejo	32100.0	32250.0	Thu Dec 18 2014 12:00:00 GMT-0800 (PST)
9	2014	Chevrolet	Camaro	LT	Convertible	automatic	2g1fb3d37e9218789	ca	3.0	4809.0	red	black	d/m auto sales inc	26300.0	17500.0	Tue Jan 20 2015 04:00:00 GMT-0800 (PST)

	year	make	model	trim	body	transmission	vin	state	condition	odometer	color	interior	seller	mmr	sellingprice	saledate
558827	2014	Jeep	Grand Cherokee	Laredo	SUV	automatic	1c4rjfag0ec466276	pa	42.0	25180.0	gray	black	hertz corporation/gdp	26000.0	24500.0	Tue Jul 07 2015 06:30:00 GMT-0700 (PDT)
558828	2012	Dodge	Grand Caravan	American Value Package	Minivan	automatic	2c4rdgbg1cr349287	ma	37.0	97036.0	silver	gray	ge fleet services for itself/servicer	8300.0	7800.0	Tue Jul 07 2015 06:30:00 GMT-0700 (PDT)
558829	2012	Hyundai	Elantra	Limited	Sedan	NaN	5npdh4ae7ch106397	pa	4.0	66720.0	gray	gray	champion mazda	10250.0	10400.0	Wed Jul 08 2015 07:30:00 GMT-0700 (PDT)
558830	2012	Nissan	Sentra	2.0 SR	Sedan	NaN	3n1ab6ap3cl622485	tn	26.0	35858.0	white	gray	nissan-infiniti lt	9950.0	10400.0	Wed Jul 08 2015 17:15:00 GMT-0700 (PDT)
558831	2011	BMW	5 Series	528i	Sedan	automatic	wbafr1c53bc744672	fl	39.0	66403.0	white	brown	lauderdale imports ltd bmw pembrok pines	20300.0	22800.0	Tue Jul 07 2015 06:15:00 GMT-0700 (PDT)
558832	2015	Kia	K900	Luxury	Sedan	NaN	knalw4d4xf6019304	in	45.0	18255.0	silver	black	avis corporation	35300.0	33000.0	Thu Jul 09 2015 07:00:00 GMT-0700 (PDT)
558833	2012	Ram	2500	Power Wagon	Crew Cab	automatic	3c6td5et6cg112407	wa	5.0	54393.0	white	black	i -5 uhlmann rv	30200.0	30800.0	Wed Jul 08 2015 09:30:00 GMT-0700 (PDT)
558834	2012	BMW	X5	xDrive35d	SUV	automatic	5uxzw0c58cl668465	ca	48.0	50561.0	black	black	financial services remarketing (lease)	29800.0	34000.0	Wed Jul 08 2015 09:30:00 GMT-0700 (PDT)
558835	2015	Nissan	Altima	2.5 S	sedan	automatic	1n4al3ap0fc216050	ga	38.0	16658.0	white	black	enterprise vehicle exchange / tra / rental / tulsa	15100.0	11100.0	Thu Jul 09 2015 06:45:00 GMT-0700 (PDT)
558836	2014	Ford	F-150	XLT	SuperCrew	automatic	1ftfw1et2eke87277	ca	34.0	15008.0	gray	gray	ford motor credit company llc pd	29600.0	26700.0	Thu May 28 2015 05:30:00 GMT-0700 (PDT)

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category